﻿<%@ Page Title="" Language="C#" MasterPageFile="~/banganyemian/banganyemian.Master" AutoEventWireup="true" CodeBehind="banchengji.aspx.cs" Inherits="zlh.banganyemian.banchengji" %>
<asp:Content ID="Content1" ContentPlaceHolderID="banContentPlaceHolder1" runat="server">
    <p>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="Label1" runat="server" Text="学号：" CssClass="word"></asp:Label>
    <asp:TextBox ID="TextBox1" runat="server" CssClass="textbox"></asp:TextBox>
    &nbsp;<asp:Button ID="Button1" runat="server" Text="查询" CssClass="button" />
    </p>
<p>
    &nbsp;&nbsp;<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="868px">
        <Columns>
            <asp:BoundField DataField="xueqi" HeaderText="xueqi" SortExpression="xueqi" />
            <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" />
            <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
            <asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
            <asp:BoundField DataField="grade" HeaderText="grade" SortExpression="grade" />
            <asp:BoundField DataField="Coursexuefen" HeaderText="Coursexuefen" SortExpression="Coursexuefen" />
            <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
        </Columns>
        <HeaderStyle CssClass="gridxiewHeaderstyle" />
        <RowStyle CssClass="gridviewrowstyle" />
    </asp:GridView>
    </p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString7 %>" SelectCommand="SELECT * FROM [Grades] WHERE ([stuNo] = @stuNo)">
        <SelectParameters>
            <asp:ControlParameter ControlID="TextBox1" Name="stuNo" PropertyName="Text" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    </p>
    <p>
    &nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString7 %>" SelectCommand="SELECT * FROM [Grades]">
    </asp:SqlDataSource>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;</p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Height="146px" HorizontalAlign="Right" Width="939px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AllowPaging="True">
        <Columns>
            <asp:BoundField DataField="xueqi" HeaderText="xueqi" SortExpression="xueqi" />
            <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" />
            <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
            <asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
            <asp:BoundField DataField="grade" HeaderText="grade" SortExpression="grade" />
            <asp:BoundField DataField="Coursexuefen" HeaderText="Coursexuefen" SortExpression="Coursexuefen" />
            <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
        </Columns>
        <HeaderStyle CssClass="gridxiewHeaderstyle" />
        <RowStyle CssClass="gridviewrowstyle" />
    </asp:GridView>
</asp:Content>
